﻿CREATE TABLE [dbo].[Service] (
    [ServiceID]                  UNIQUEIDENTIFIER NOT NULL,
    [FarmID]                     UNIQUEIDENTIFIER NOT NULL,
    [CanUpgrade]                 BIT              NULL,
    [NeedsUpgrade]               BIT              NULL,
    [NeedsUpgraeIncludeChildren] BIT              NULL,
    [Required]                   BIT              NULL,
    [Status]                     VARCHAR (200)    NULL,
    [TypeName]                   VARCHAR (200)    NULL,
    [Version]                    INT              NULL,
    CONSTRAINT [PK_Service_1] PRIMARY KEY CLUSTERED ([ServiceID] ASC),
    CONSTRAINT [FK_Service_Farm] FOREIGN KEY ([FarmID]) REFERENCES [dbo].[Farm] ([FarmID])
);

